package com.spring.shops.dao;

import com.spring.shops.model.entity.TzTranscity;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TzTranscityMapper {
    int deleteByPrimaryKey(Long transcityId);

    int insert(TzTranscity record);

    int insertSelective(TzTranscity record);

    TzTranscity selectByPrimaryKey(Long transcityId);

    int updateByPrimaryKeySelective(TzTranscity record);

    int updateByPrimaryKey(TzTranscity record);

    /**
     * 根据运费项id查询免免费城市id
     * @param feeId
     * @return
     */
    @Select("select city_id from yami_shops.tz_transcity where transfee_id=#{feeId}")
    List<Long> getCityIdByFeeId(Long feeId);
}